
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vSmartTechParticipant
AS
SELECT     dbo.SmartTechInterviews.InterviewTime, dbo.SmartTechWorkshop.Name AS Workshop, dbo.SmartTechWorkshop.Comments, dbo.College.Name AS School, 
                      dbo.SmartTechParticipant.Id, dbo.SmartTechParticipant.Name, dbo.SmartTechParticipant.Mobile, dbo.SmartTechParticipant.Email, dbo.SmartTechParticipant.SchoolId, 
                      dbo.SmartTechParticipant.WorkshopId, dbo.SmartTechParticipant.InterviewId, dbo.SmartTechParticipant.TimeStamp, dbo.SmartTechParticipant.Online, 
                      dbo.SmartTechParticipant.Barcode
FROM         dbo.SmartTechParticipant INNER JOIN
                      dbo.SmartTechWorkshop ON dbo.SmartTechParticipant.WorkshopId = dbo.SmartTechWorkshop.Id INNER JOIN
                      dbo.SmartTechInterviews ON dbo.SmartTechParticipant.InterviewId = dbo.SmartTechInterviews.Id INNER JOIN
                      dbo.College ON dbo.SmartTechParticipant.SchoolId = dbo.College.Id
GO

EXEC sp_addextendedproperty N'MS_DiagramPane2', N'      NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'SCHEMA', N'dbo', 'VIEW', N'vSmartTechParticipant', NULL, NULL
GO

EXEC sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[59] 4[9] 2[27] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "SmartTechParticipant"
            Begin Extent = 
               Top = 57
               Left = 291
               Bottom = 263
               Right = 448
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "SmartTechWorkshop"
            Begin Extent = 
               Top = 191
               Left = 10
               Bottom = 295
               Right = 170
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "SmartTechInterviews"
            Begin Extent = 
               Top = 241
               Left = 525
               Bottom = 345
               Right = 685
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "College"
            Begin Extent = 
               Top = 52
               Left = 40
               Bottom = 141
               Right = 200
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 16
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
   ', 'SCHEMA', N'dbo', 'VIEW', N'vSmartTechParticipant', NULL, NULL
GO

DECLARE @xp int
SELECT @xp=2
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'SCHEMA', N'dbo', 'VIEW', N'vSmartTechParticipant', NULL, NULL
GO
